County Profile for Mercer - 2017



County Controls Information

Cost Report Counts Population
Total Hospital Count 6 Total Population on July 31, 2017 0
Total Cost Reports Filed in 2017 6 Total Births 0
Total Cost Reports Submitted 0 Total Deaths 0
Total Cost Reports Settled 3 Net Population Natural Change 0
Total Cost Reports Reopened 3 Total International Migration 0
Total Cost Reports Ammended 0 Total Domestic Migration 0
Total Cost Reports Audited 0 Total Residual 0
Net Population Change 0

County Financial Statements - Worksheet G

Balance Sheet Income Statement
Current Assets 366,746,870 Total Charges 8,045,219,731
Fixed Assets 654,255,228 Contract Allowance 7,082,608,808
Other Assets 556,077,624 Operating Revenue 962,610,923
Total Assets 1,577,079,722 Operating Expenses 1,130,587,223
Current Liabilities 172,912,344 Operating Margin -167,976,300
Long Term Liabilities 1,286,919,704 Other Income 19,605,846
Total Equity 117,247,674 Other Expense 180,000
Total Liabilities and Equity 1,577,079,722 Net Profit or Loss -148,550,454

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $31,374 Revenue per Bed $996,492 Revenue per Person $962,610,923
Net Margin per Discharge ($5,475) Net Margin per Bed ($173,889) Net Margin per Person ($167,976,300)
Net Profit per Discharge ($4,842) Net Profit per Bed ($153,779) Net Profit per Person ($148,550,454)
Net Fixed Assets per Discharge $21,324 Net Fixed Assets per Bed $677,283 Net Fixed Assets per Bed $654,255,228
Long Term Debt per Discharge $41,944 Long Term Debt per Bed $1,332,215 Long Term Debt per Person $1,286,919,704
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 74.5 %
Length of Stay 9 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 101 Net Fixed Assets 156 Population Estimate 1,151
Total Revenue 227 Long Term Liabilities 55 Total Patient Discharges 269
Net Margin 3,248 Total Patient Beds 165
Net Profit or Loss 3,289

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 264,677,944 1,349,958,715 0.1961
31 Intensive Care Unit 59,259,005 352,990,087 0.1679
32 Coronary Care Unit 6,521,979 42,188,908 0.1546
43 Nursery 13,439,363 112,402,175 0.1196
44 Skilled Nursing Care 7,411,779 6,765,023 1.0956
50 Operating Room 62,899,102 503,473,240 0.1249
51 Recovery Room 12,325,209 66,179,900 0.1862
52 Labor and Delivery Room 18,374,615 41,654,687 0.4411

County General Service Cost - Worksheet A

Lines Description Amount Lines Description Amount
01 Capital Related - Building and Fixtures 95,036,234 13 Nursing Administration 14,138,482
02,03 Captial Related - Movable Equipment 28,044,067 14 Central Services and Supply 6,248,987
04 Employee Benefits 114,993,055 15 Pharmacy 13,222,503
05 Administrative and General 169,495,892 16 Medical Records and Medical Library 8,335,278
06 Maintenance and Repairs 18,776,697 17 Social Services 5,557,987
07 Operation of Plant 26,691,945 18 Other General Service Expense -761
08,09 Laundry, Linen and Housekeeping 17,213,532 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 15,708,684 20,21,22,23 Education Programs 5,284,510
Total General Service Cost Centers 538,747,092

County Profile for Mercer - 2017